package com.code.dao;

import com.code.entity.QueryPageBean;
import com.code.pojo.Order;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;
import java.util.Map;

public interface OrderMapper extends Mapper<Order> {
    @Select("select p.name name,o.price,count(o.id) value from tb_product p left join tb_order o on o.pid=p.id group by p.id")
    List<Map> tongji();

    List<Order> findLike(QueryPageBean queryPageBean);

    List<Order> findPageNo(QueryPageBean queryPageBean);

}
